# name : xlsx, date to SAS formate
# key : xlsx.date.to.sas
# contributor: Shuguang Sun
# --
${1:datevar} = input(${2:xlsxvar}, ??date11.);
format $2 yymmdd10.;
if missing($1) and 1 <= input($2, ??32.) <= 50000 then do;
$1 = int(input($2, ??32.)) + '30dec1899'd;
end;